Release 10.1A: OpenEdge Development:
Basic Database Tools

Edit Auto-Connect List option

Choose Utilities Edit Auto-Connect List to create or modify the auto-connect list. The auto-connect list is a list of secondary databases (with connection parameters) that are connected automatically as required during program execution on a primary database. You can define one for each OpenEdge database.

Note: To use the Auto-Connect feature for non-OpenEdge databases, use the Edit Connection Parameters option under the appropriate DataServer submenu option. See the appropriate DataServer manual for information on auto-connecting to non-OpenEdge databases.

The auto-connect feature uses information stored in a primary application database to connect to a secondary application database. The primary application database contains the database connection information for the secondary database. When data from the second database is referenced in a compiled application at run time, the primary application database must already be connected before the database engine can execute the auto-connect for the secondary application database. The database engine executes an auto-connect immediately prior to running a procedure that accesses a database on the auto-connect list. If you connect a database with the CONNECT statement, and that database also has an auto-connect entry in an already connected database, the CONNECT statement uses the information from the auto-connect list; however, the explicit connection information in the CONNECT statement takes precedence. For more information about auto-connect, see the chapter on database access in OpenEdge Development: Programming Interfaces .

When you choose this option, the Edit Auto-Connect List dialog box shown in Figure 11–10 appears.

Figure 11–10: Edit Auto-Connect List dialog box

The Edit Auto-Connect List dialog box contains the following user-interface elements:

Database Name

Displays the list of databases to which the database engine connects automatically.

Logical Database Name

Specifies the logical name of the database highlighted in the Database Name list.

Physical Database Name

Specifies the physical name of the database highlighted in the Database Name list.

CONNECT-Statement Parameters

Specifies any other startup parameters for the database that are not included in the parameter file.

Table 11–5 describes the buttons on the Edit Auto-Connect List dialog box.

Table 11–5: Edit Auto-Connect List options 

Option	Action
Next	Displays the next connect record.
Prev	Displays the previous connect record.
First	Displays the first connect record.
Last	Displays the last connect record.
Add	Adds a new connect record.
Modify	Modifies the selected connect record.
Delete	Deletes the selected connect record.
Undo	Exits, undoes all changes you made in this session to the Auto Connect list, and returns to the Data Administration window.
Exit	Exits, saves changes, and returns to the Data Administration window.